load data
truncate                                       
into table CRST_PO_REQ_DISTRIBUTIONS_ALL
fields terminated by "	"                      
trailing nullcols 
( DISTRIBUTION_ID              ,
  LAST_UPDATE_DATE             Date "YYYYMMDD HH24:MI:SS",
  LAST_UPDATED_BY              ,
  REQUISITION_LINE_ID          ,
  SET_OF_BOOKS_ID              ,
  CODE_COMBINATION_ID          ,
  REQ_LINE_QUANTITY            ,
  LAST_UPDATE_LOGIN            ,
  CREATION_DATE                Date "YYYYMMDD HH24:MI:SS",
  CREATED_BY                   ,
  ENCUMBERED_FLAG              ,
  GL_ENCUMBERED_DATE           Date "YYYYMMDD HH24:MI:SS",
  GL_ENCUMBERED_PERIOD_NAME    ,
  GL_CANCELLED_DATE            Date "YYYYMMDD HH24:MI:SS",
  FAILED_FUNDS_LOOKUP_CODE     ,
  ENCUMBERED_AMOUNT            ,
  BUDGET_ACCOUNT_ID            ,
  ACCRUAL_ACCOUNT_ID           ,
  VARIANCE_ACCOUNT_ID          ,
  PREVENT_ENCUMBRANCE_FLAG     ,
  ATTRIBUTE_CATEGORY           ,
  ATTRIBUTE1                   ,
  ATTRIBUTE2                   ,
  ATTRIBUTE3                   ,
  ATTRIBUTE4                   ,
  ATTRIBUTE5                   ,
  ATTRIBUTE6                   ,
  ATTRIBUTE7                   ,
  ATTRIBUTE8                   ,
  ATTRIBUTE9                   ,
  ATTRIBUTE10                  ,
  ATTRIBUTE11                  ,
  ATTRIBUTE12                  ,
  ATTRIBUTE13                  ,
  ATTRIBUTE14                  ,
  ATTRIBUTE15                  ,
  USSGL_TRANSACTION_CODE       ,
  GOVERNMENT_CONTEXT           ,
  REQUEST_ID                   ,
  PROGRAM_APPLICATION_ID       ,
  PROGRAM_ID                   ,
  PROGRAM_UPDATE_DATE          Date "YYYYMMDD HH24:MI:SS",
  PROJECT_ID                   ,
  TASK_ID                      ,
  END_ITEM_UNIT_NUMBER         ,
  EXPENDITURE_TYPE             ,
  PROJECT_ACCOUNTING_CONTEXT   ,
  EXPENDITURE_ORGANIZATION_ID  ,
  GL_CLOSED_DATE               Date "YYYYMMDD HH24:MI:SS",
  SOURCE_REQ_DISTRIBUTION_ID   ,
  DISTRIBUTION_NUM             ,
  ALLOCATION_TYPE              ,
  ALLOCATION_VALUE             ,
  PROJECT_RELATED_FLAG         ,
  EXPENDITURE_ITEM_DATE        Date "YYYYMMDD HH24:MI:SS",
  ORG_ID                       ,
  AWARD_ID                     ,
  RECOVERABLE_TAX              ,
  NONRECOVERABLE_TAX           ,
  RECOVERY_RATE                ,
  TAX_RECOVERY_OVERRIDE_FLAG   ,
  OKE_CONTRACT_LINE_ID         ,
  OKE_CONTRACT_DELIVERABLE_ID  
)
